Create Spreadsheet
Description
Google Spreadsheets: Create Spreadsheet step, creates a new spreadsheet on Google Drive.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| Connection: | Refer Prerequisites and References above to get the connection attributes. | |
| 2 | Client ID | Specify Client ID of the Google application. The data type is String. This field is mandatory. |
| Client Secret: | ||
| 3 | Accept Values from fields | Leave checkbox unchecked to accept Client Secret value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Secret Key field to appear as Text box. |
| 4 | Client Secret | Specify Client Secret of the Google application. If checkbox above is enabled Client Secret field appears as Text box and accepts static values or variables. Else if checkbox above is disabled Client Secret field appears as a drop down containing values from previous steps - to select from. The data type is String. This field is mandatory. |
| Refresh Token | ||
| 5 | Accept Values from fields | Leave checkbox unchecked to accept Secret Key value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Secret Key field to appear as Text box. |
| 6 | Refresh Token | Specify a Refresh Token to obtain a new Access Token. **Note:**Refresh Token expires if idle for 6 months. If checkbox above is enabled Refresh Token field appears as Text box and accepts static values or variables. Else if checkbox above is disabled Refresh Token field appears as a drop down containing values from previous steps - to select from. The data type is String. This field is mandatory. |
| 7 | Button: Test Connection | Verifies whether the connection is established or not. **Note:**For the purpose of verification fields coming from previous steps are not allowed since field values can only be accessed when workflow is in running state; only static values and environment variables are allowed. |
| Input Fields | ||
| 1 | Spreadsheet Name | Specify a new Spreadsheet name to be created. The data type is String. This field is mandatory. **Note:**A Work Sheet is created with the default name Sheet1. |
| Output Field | ||
| 1 | Spreadsheet ID | Specify an output field to hold the Spreadsheet ID of the created Spreadsheet. The date type is string. This field is mandatory. |